forum

home / developersection / forums / how to find the first and last data of sql using linq?

Ask Question

How to find the first and last data of SQL using LINQ?

Ethan Karla 585 24-Sep-2021

How to find the first and last data of SQL Database using LINQ?

linq c#  ado.net  linq 
Updated on 24-Sep-2021
Ethan Karla

Student

An enthusiastic, adaptive, and fast-learning person with a broad and acute interest in the discovery of new innovative drugs, I particularly enjoy collaborating with scientists from different disciplines to develop new skills and solve new challenges.

Follow
Can you answer this question?
Answer

1 Answers

Ravi Vishwakarma

Ravi Vishwakarma

27-Sep-2021

We use the First and Last methods in LINQ for finding the first element and last element.

  1. First() are used to fetching the first row data from SQL and we can use the FirstOrDefault() method 
  2. Last() are used to fetching the last row data from SQL and we can use the LastOrDefault() method
using System;
using System.Collections.Generic;
using System.Linq;

public class Program
{
 public static void Main()
 {

  List<Student> students = new List<Student>()
  {
  new Student() { StudentId = 1, Name = 'Ashu', Marks = 500 },
  new Student() { StudentId = 2, Name = 'Shyam', Marks = 300 },
  new Student() { StudentId = 3, Name = 'Shriyam', Marks = 400 },
  new Student() { StudentId = 4, Name = 'Sunny', Marks = 550 },
  new Student() { StudentId = 5, Name = 'Ram', Marks = 600 },
  new Student() { StudentId = 6, Name = 'Krishna', Marks = 700 },
  new Student() { StudentId = 7, Name = 'Anupam', Marks = 550 }
  };

  List<Student> list = students.Where( stu => stu.Marks > 500).ToList();

  Console.WriteLine('\nAll value :\n');
  Console.WriteLine('{0,-10} {1,10} {2,5}','Name', 'ID', 'Marks');
  list.ForEach( student => Console.WriteLine('{0,-10} {1,10} {2,5}', student.Name, student.StudentId, student.Marks) );

  Student first = students.Where( stu => stu.Marks > 500).First();

  Console.WriteLine('\nFirst() :\n');
  Console.WriteLine('{0,-10} {1,10} {2,5}','Name', 'ID', 'Marks');
  Console.WriteLine('{0,-10} {1,10} {2,5}', first.Name, first.StudentId, first.Marks);

  Student last = students.Where( stu => stu.Marks > 500).Last();

  Console.WriteLine('\nLast() :\n');
  Console.WriteLine('{0,-10} {1,10} {2,5}','Name', 'ID', 'Marks');
  Console.WriteLine('{0,-10} {1,10} {2,5}', last.Name, last.StudentId, last.Marks);

  Console.ReadLine();
 }
}

class Student
{
public int StudentId { get; set; }
public string Name { get; set; }
public int Marks { get; set; }
}

Output

All value :

Name               ID Marks
Sunny               4   550
Ram                 5   600
Krishna             6   700
Anupam              7   550

First() :

Name               ID Marks
Sunny               4   550

Last() :

Name               ID Marks
Anupam              7   550

advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy